﻿CREATE TRIGGER UsersRoles_Tracking_Update
ON [dbo].[UsersRoles] 
AFTER Update
AS 
BEGIN
	UPDATE Sync.UsersRoles_Tracking 
	SET LastUpdatedDate  = getdate()
    FROM Sync.UsersRoles_Tracking s JOIN INSERTED i
    ON s.RoleID = i.RoleID AND s.UserID = i.UserID
END














